Error in query: select distinct tbltwar.id,tbltwar.rdate,rbanner,rheadline,tindex,get_ccount(tbltwar.id) as comments, viewcount,
get_last_poster(tbltwar.id) as lastp,get_last_timestamp(tbltwar.id) as dtg,get_last_cid(tbltwar.id) as lastcid
from tbltwar
left join tblcategories on tblcategories.category=tbltwar.rheadline
left join tblpghitz on tblpghitz.id=tbltwar.id
where tbltwar.tindex= echo $HC ?> and tbltwar.rdate='04/29/2024' and published='YES' and tblcategories.category = ' echo $SO ?>' order by tindex,id desc nulls first. ERROR: syntax error at or near "$"
LINE 6: where tbltwar.tindex= echo $HC ?> and tbltwar....
^ |